Please wait while your action is being processed..
SELECT A.id AS issue_id, A.menu_id, A.name AS report_type, A.report_type AS report_template,
A.disclosure_text, A.enable_disclaimer, A.disclaimer_text, A.disclaimer_phone, A.issue_image,A.location_required,M.rai_kml_url
FROM tbl_rai_issues A, tbl_rai_department D, tbl_menus M
WHERE A.cityhash_id = '50fcbb1aa0e7601ef3aaa791609bdefa'
AND A.menu_id = M.id
AND M.deleted = 'no'
AND A.deleted = 'no'
AND A.rai_department_id = D.id
AND A.status NOT IN('deleted','deactive')
AND A.work_flow='AAQ'
AND A.issue_access IN('all','citizen')
ORDER BY A.name ASC
